<%@ page import="java.sql.*" %>
<html>
<body bgcolor="#fdfec5">
<center><img src="images/12.jpeg" border=0 width=263 height=128><img src="images/11.jpeg" border=0 width=263 height=128><img src="images/14.jpeg" border=0 width=263 height=128>
<br><br><br>
<marquee align="left"><font color="#1589FF" size="5"><b><i><u>Transactions Details Of Customer Are Running Properly</u></i></b></font></marquee>
<%
try
{
		

  Class.forName("oracle.jdbc.driver.OracleDriver");
   Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","bank","bank");
  Statement st=con.createStatement();
 ResultSet rs=st.executeQuery("select *  from checkdetails ");%>
<table center border=1 style="position:absolute; overflow:hidden; left:310px; top:250px; width:500px; height:56px; z-index:18" bgColor="#c4c4ff">
	 	
	 	<tr><th bgcolor="#FF6600" colspan="0">AccNo</th>
	 	<th bgcolor="#FF6600" colspan="0">CheckNo</th>
   		<th bgcolor="#FF6600" colspan="0">IssuedTo</th>
    	<th bgcolor="#FF6600" colspan="0">Date</th>
    	<th bgcolor="#FF6600" colspan="0">Status</th></tr>
       <%while(rs.next())
	{
	
	%>
	   <tr><td bgcolor="#e6e6e6"><%=rs.getString(1)%></td>
           <td bgcolor="#e6e6e6"><%=rs.getString(2)%></a></td>
    		<td bgcolor="#e6e6e6"><%=rs.getString(3) %></td>
     		<td bgcolor="#e6e6e6"><%=rs.getString(4) %></td>
      		<td bgcolor="#e6e6e6"><%=rs.getString(5) %></td>
    	</tr>
    <%}
    st.close();
    rs.close();
    con.close(); 
    %>
    </table>
    <%}
   		catch(Exception e)
	{
	System.out.println(e);
	}
%>